package service;

import pojo.Department;
import pojo.Log;
import pojo.LogFamily;
import pojo.User;

import java.sql.SQLException;
import java.util.List;

/**
 * Created by Administrator on 2017-11-26.
 */
public interface LogService {
    List<LogFamily> getLogFamily() throws SQLException;

    int writeLog(Log log) throws SQLException;

    List<Log> getAllLog(Integer id) throws SQLException;

    int getCount(Integer id);

    List<Log> getCurrentLog(Integer id, int pageNow, int i) throws SQLException;

    Log lookCurrentLog(int id) throws SQLException;

    int updateLog(Log log) throws SQLException;

    int deleteLog(int id) throws SQLException;

    List<Log> getDoubleConditionLog(Integer id, int pageNow, int pageSize, String logFamily, String logStatus) throws SQLException;

    List<Log> getFirstConditionLog(Integer id, int pageNow, int pageSize, String logFamily) throws SQLException;

    List<Log> getSecondConditionLog(Integer id, int pageNow, int pageSize, String logFamily) throws SQLException;

    List<Log> getAllLogByLogFamilyAndLogStatus(Integer id,String logFamily,String logStatus) throws SQLException;

    List<Log> getAllLogByLogFamily(Integer id,String logFamily) throws SQLException;

    List<Log> getAllLogByLogStatus(Integer id,String logStatus) throws SQLException;

    List<Log> checkAllLog(String logStatus,String department) throws SQLException;

    List<Log> checkLog(String logStatus,String department, int pageNow,int pageSize) throws SQLException;

    Log getLog(int id) throws SQLException;

    int check(int id, String logStatus) throws SQLException;

    List<Log> getPassLog(String logStatus) throws SQLException;

    List<Log> getCurrentPassLog(String logStatus,String department, int pageNow, int pageSize) throws SQLException;

    List<Log> getFirstConditionCurrentPassLog(String logStatus,String department, String logFamily, int pageNow, int pageSize) throws SQLException;

    List<Log> getPassLogByLogFamily(String logFamily,String department, String logStatus) throws SQLException;

    List<Department> selectDepartment() throws SQLException;

    List<Log> selectAllLog() throws SQLException;

    List<Log> getCurrentAllLog(int pageNow, int page_size)throws SQLException;

    List<Log> selectAllLogByDoubleCondition(String department, String logFamily)throws SQLException;

    List<Log> getCurrentLogByDepartmentAndLogFamily(String department, String logFamily, int pageNow, int page_size)throws SQLException;

    List<Log> selectAllLogByFirstCondition(String department)throws SQLException;

    List<Log> getCurrentLogByDepartment(String department, int pageNow, int page_size)throws SQLException;

    List<Log> selectAllLogBySecoundCondition(String logFamily)throws SQLException;

    List<Log> getCurrentLogByLogFamily(String logFamily, int pageNow, int page_size)throws SQLException;

    List<LogFamily> selectLogFamily() throws SQLException;
}
